Tabela DrugActiveSubst

Definicja tabeli DrugActiveSubst

Name

DrugActiveSubst

Code

DrugActiveSubst

Comment

 


Lista kolumn tabeli DrugActiveSubst

Name

Code

DrugActiveSubstID

DrugActiveSubstID

DrugDBTypeID

DrugDBTypeID

DrugNo

DrugNo

ActiveSubstance

ActiveSubstance

DosageQuantity

DosageQuantity

DosageUnit

DosageUnit

HashCode

HashCode

DosageVolume

DosageVolume

DosageVolumeUnit

DosageVolumeUnit

Active

Active


Kolumna DrugActiveSubstID tabeli DrugActiveSubst

Definicja kolumny DrugActiveSubstID tabeli DrugActiveSubst

Name

DrugActiveSubstID

Code

DrugActiveSubstID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DrugDBTypeID tabeli DrugActiveSubst

Definicja kolumny DrugDBTypeID tabeli DrugActiveSubst

Name

DrugDBTypeID

Code

DrugDBTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

FK do Drug


Kolumna DrugNo tabeli DrugActiveSubst

Definicja kolumny DrugNo tabeli DrugActiveSubst

Name

DrugNo

Code

DrugNo

Data Type

VARCHAR2(16)

Mandatory

Yes

Comment

FK do Drug


Kolumna ActiveSubstance tabeli DrugActiveSubst

Definicja kolumny ActiveSubstance tabeli DrugActiveSubst

Name

ActiveSubstance

Code

ActiveSubstance

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

substancja czynna


Kolumna DosageQuantity tabeli DrugActiveSubst

Definicja kolumny DosageQuantity tabeli DrugActiveSubst

Name

DosageQuantity

Code

DosageQuantity

Data Type

NUMBER(18,8)

Mandatory

No

Comment

ilosc dawki


Kolumna DosageUnit tabeli DrugActiveSubst

Definicja kolumny DosageUnit tabeli DrugActiveSubst

Name

DosageUnit

Code

DosageUnit

Data Type

VARCHAR2(16)

Mandatory

No

Comment

ednostka dawki


Kolumna HashCode tabeli DrugActiveSubst

Definicja kolumny HashCode tabeli DrugActiveSubst

Name

HashCode

Code

HashCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

hashCode rekordu


Kolumna DosageVolume tabeli DrugActiveSubst

Definicja kolumny DosageVolume tabeli DrugActiveSubst

Name

DosageVolume

Code

DosageVolume

Data Type

NUMBER(18,8)

Mandatory

No

Comment

 


Kolumna DosageVolumeUnit tabeli DrugActiveSubst

Definicja kolumny DosageVolumeUnit tabeli DrugActiveSubst

Name

DosageVolumeUnit

Code

DosageVolumeUnit

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna Active tabeli DrugActiveSubst

Definicja kolumny Active tabeli DrugActiveSubst

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

 


Lista kluczy tabeli DrugActiveSubst

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DrugActiveSubst

Definicja klucza Identifier_1 tabeli DrugActiveSubst

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment